import pandas as pd

excel_file_path = r"G:\ututes\Code\tools\ututes_html_process\resources\excel\text.xlsx"

data = {
    ('Name', 'first'): ['John1', 'John2', 'John3'],
    ('Name', 'last'): ['Doe1', 'Doe2', 'Doe3'],
    'Age': [25, 30, 35],
    ('Address', 'country'): ['USA1', 'USA2', 'USA3'],
    ('Address', 'province'): ['California1', 'California2', 'California3'],
    ('Address', 'city'): ['San Francisco1', 'San Francisco2', 'San Francisco3']
}

df = pd.read_excel(excel_file_path, header=[0, 1])
print(df)
header = [('Name', 'first'), ('Name', 'last'), 'Age', ('Address', 'country'), ('Address', 'province'),
          ('Address', 'city')]

columns = df.columns.tolist()
print(columns)
print(df.shape)
